﻿CREATE TABLE [dbo].[tblStg_DbTblInd_Names]
(
	[bti_id] INT IDENTITY(1, 1) NOT NULL, 
	[bti_server_ssd_id] INT NOT NULL, 
	[bti_databaseid] INT NOT NULL, 
	[bti_tableid] INT NOT NULL, 
	[bti_indexid] INT NOT NULL, 
	[bti_databasename] VARCHAR(256) NULL, 
	[bti_tablename] VARCHAR(256) NULL, 
	[bti_indexname] VARCHAR(256) NULL, 
	[bti_startdate] DATETIME NOT NULL CONSTRAINT [DF_tblStg_DbTblInd_Names_startdate] DEFAULT ('01/01/1900'),
	[bti_enddate] DATETIME NULL, 
	CONSTRAINT [PK_tblStg_DbTblInd_Names] PRIMARY KEY ([bti_id])
)
GO

CREATE INDEX [IX_tblStg_DbTblInd_Names_DbTblInd] ON [dbo].[tblStg_DbTblInd_Names] ([bti_server_ssd_id], [bti_databaseid], [bti_tableid], [bti_indexid])
GO